create external table jms_dm.dm_end_dispatch_saven_zero_out_cnt_dt
(
update_time date comment '统计时间',
manage_code string comment '管理大区',
manage_name string comment '管理大区名称',
agent_code string comment '代理区编码',
agent_name string comment '代理区名称',
franchisee_code string comment '加盟商编码',
franchisee_name string comment '加盟商名称',
network_code string comment '网点编码',
network_name string comment '网点名称',
store_code string comment '门店编码',
store_name string comment '门店名称',
store_in_total int comment '门店入库量',
store_cnt_0 int comment '0出库驿站数'
)
COMMENT '末端代派-7日零出库驿站数'
PARTITIONED BY (
  `dt` string COMMENT '入库扫描的录入时间')
    stored as parquet
    location '/dw/hive/jms_dm.db/external/dm_end_dispatch_saven_zero_out_cnt_dt'
    tblproperties (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );
